
db.CorporateData.createIndex({ CompanyId: 1 }, { unique: true, name: "CompanyId" });
db.CorporateData.createIndex({ CompanyName: 1 }, { unique: true, name: "CompanyName" });
db.CorporateData.createIndex({ CompanyType: 1 }, { name: "CompanyType" });
db.CorporateData.createIndex({ Country: 1 }, { name: "Country" });
db.CorporateData.createIndex({ Region: 1 }, { name: "Region" });
db.CorporateData.createIndex({ RootPeerGroup: 1 }, { name: "RootPeerGroup" });
db.CorporateData.createIndex({ GICSSector: 1 }, { name: "GICSSector" });
db.CorporateData.createIndex({ GICSIndustryGroup: 1 }, { name: "GICSIndustryGroup" });
db.CorporateData.createIndex({ GICSIndustry: 1 }, { name: "GICSIndustry" });
db.CorporateData.createIndex({ GICSSubIndustry: 1 }, { name: "GICSSubIndustry" });
db.CorporateData.createIndex({ CapitalIQID: 1 }, { name: "CapitalIQID" });
db.CorporateData.createIndex({ TotalEmployees: 1 }, { name: "TotalEmployees" });

db.FinancialData.createIndex({ CompanyId: 1 }, { unique: true, name: "CompanyId" });
db.CorporateData.createIndex({ CompanyName: 1 }, { unique: true, name: "CompanyName" });
db.FinancialData.createIndex({ MarketCapitalization: 1 }, { name: "MarketCapitalization" });
db.FinancialData.createIndex({ NEBT: 1 }, { name: "NEBT" });
db.FinancialData.createIndex({ NetIncome: 1 }, { name: "NetIncome" });
db.FinancialData.createIndex({ TotalRevenues: 1 }, { name: "TotalRevenues" });

db.ReferenceData.createIndex({ CompanyId: 1 }, { unique: true, name: "CompanyId" });
db.CorporateData.createIndex({ CompanyName: 1 }, { unique: true, name: "CompanyName" });
db.ReferenceData.createIndex({ ISINs: 1 }, { name: "ISINs" });
db.ReferenceData.createIndex({ Sedols: 1 }, { name: "Sedols" });
db.ReferenceData.createIndex({ Exchanges: 1 }, { name: "Exchanges" });
db.ReferenceData.createIndex({ Tickers: 1 }, { name: "Tickers" });
db.ReferenceData.createIndex({ CUSIPs: 1 }, { name: "CUSIPs" });

db.Country.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.Region.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });

db.RootPeerGroup.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.PeerGroup.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });

db.GICSSubIndustry.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.GICSIndustry.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.GICSIndustryGroup.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.GICSSector.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });

db.ISIN.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.Sedol.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.Exchange.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.Ticker.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });
db.CUSIP.createIndex({ Name: 1 }, { unique: true, name: "UniqueName" });


db.EventIndicator.createIndex({ CompanyId: 1 }, { name: "CompanyId" });
db.EventIndicator.createIndex({ CompanyId: 1, BaseEventIndicatorId: 1 }, { unique: true, name: "EventIndicator" });
db.EventIndicator.createIndex({ BaseEventIndicatorId: 1 }, { name: "BaseEventIndicatorId" });
db.EventIndicator.createIndex({ AnswerCategory: 1 }, { name: "AnswerCategory" });

db.IndicatorTemplate.createIndex({ Number: 1 }, { unique: true, name: "IndicatorTemplateNumber" });

db.RpIndicator.createIndex({ CompanyId: 1 }, { name: "CompanyId" });
db.RpIndicator.createIndex({ Number: 1 }, { name: "Number" });
db.RpIndicator.createIndex({ 'SelectedAnswer.Score': 1 }, { name: "AnswerCategoryScore" });